﻿CREATE TABLE [dbo].[SALESTrackingReport] (
    [endOfDayID]               INT             IDENTITY (1, 1) NOT NULL,
    [userID]                   INT             NOT NULL,
    [locationID]               INT             NOT NULL,
    [submittedDate]            DATETIME        NOT NULL,
    [endOfDayDate]             DATETIME        NOT NULL,
    [startingCash]             NUMERIC (7, 2)  NOT NULL,
    [endingCash]               NUMERIC (7, 2)  NOT NULL,
    [dailySales]               NUMERIC (7, 2)  NOT NULL,
    [dailySalesWholesale]      NUMERIC (7, 2)  NULL,
    [dailyMarginDollars]       NUMERIC (7, 2)  NOT NULL,
    [dailyMarginPerc]          NUMERIC (7, 2)  NOT NULL,
    [dailySalesGramsRetail]    INT             NOT NULL,
    [dailySalesGramsWholesale] INT             NOT NULL,
    [dailySalesCash]           NUMERIC (7, 2)  NOT NULL,
    [dailySalesCredit]         NUMERIC (7, 2)  NOT NULL,
    [numCustomers]             INT             NOT NULL,
    [newsignovers]             INT             NULL,
    [notes]                    NVARCHAR (3000) NULL
);

